package org.jxau.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jxau.bean.Systems;
import org.jxau.bean.UserInfo;

public interface UserInfoMapper {
	@Select("select * from userinfo where id=#{id} and pwd=#{pwd}")
	UserInfo getUserInfoByIdAndName(@Param("id")Integer id,@Param("pwd")String pwd);
	
	@Select("select * from systems where id in(select sid from rolesystems where rid=#{id})")
	List<Systems> getSystemOfRoles(Integer id);
	
	@Select("select * from systems")
	List<Systems> getAllSystems(); 
}
